Creating A Database

Creating a database is a two-step process. First, you design and create the table. Second, you enter data into the table.

Creating A Table
The table defines the structure or organization of your database. It specifies the type of data and where the data will be located.

You must plan the overall design of your database and decide what categories of information to include so that you can retrieve and display the information you need. This includes defining fields.

Each field requires the following:

    Field name: unique name describing the field. Rules for field names include:

    1.A name can be up to 64 characters long.
    2.
    		A name can contain letters, spaces, digits, and most punctuation symbols EXCEPT these characters: . ! [ ]
    3.Each name must be unique within the table.
    4.
    		The primary key field must contain unique information for each record.

    Field type: indicates the type of data to be stored in the field. These include:


      text, numbers, currency, date/time, memo, AutoNumber, Yes/No, and OLE object.

    Field description: detailed information about the field. This is optional.